package com.trxy.hotelsystem.dao;

import java.util.List;

import com.trxy.hotelsystem.model.consumptionRecord;

public interface consumptionRecordMapper {
    int deleteByPrimaryKey(String serialnum);

    int insert(consumptionRecord record);

    int insertSelective(consumptionRecord record);

    consumptionRecord selectByPrimaryKey(String serialnum);

    int updateByPrimaryKeySelective(consumptionRecord record);

    int updateByPrimaryKey(consumptionRecord record);
    
    List<consumptionRecord> selectConsumption_recordByvipNumber(String vipNumber);
    
    List<consumptionRecord> queryConsumption_recordAll();
    
    List<consumptionRecord> selectConsump_Record(consumptionRecord consumptionRecord);
    
    double sumConsump_RecordByvipNumber(String vipNumber);
    
}